USE [MMS]
GO

/****** Object:  Table [dbo].[MMS_ASSET]    Script Date: 11/27/2012 06:52:12 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[MMS_ASSET](
	[id] [int] NOT NULL,
	[CusId] [int] NULL,
	[Status] [int] NULL,
	[AssetType] [int] NULL,
	[AssetName] [nvarchar](max) NULL,
	[ValuationId] [int] NULL,
	[LoanId] [int] NULL,
	[RateId] [int] NULL,
	[CreateDate] [datetime] NULL,
	[CreateUid] [int] NULL,
	[UpdateDate] [datetime] NULL,
	[UpdateUid] [int] NULL,
	[Freeze] [varchar](1) NULL,
 CONSTRAINT [PK_MMS_PROPERTY] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


